<?php

class EquipmentController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column2';
        public $customer;
        public $location;
	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
				
				'users'=>array('@'),
			),
			
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	/**

	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate($custno,$locno)
	{
		$model=new Equipment;
                $model->custno=$custno;
                $model->locno=$locno;
                      
		$this->loadObject($custno, $locno);

		if(isset($_POST['Equipment']))
		{
			$model->attributes=$_POST['Equipment'];
			
				
		}
                if($model->save()){
                    $this->redirect(array('update','id'=>$model->id));
                }else{
                    throw new CHttpException('Error while creating new equipment');
                }
            
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id)
	{
		$model=$this->loadModel($id);
                $custno=$model->custno;
                $locno=$model->locno;
                $this->loadObject($custno, $locno);
		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Equipment']))
		{
			$model->attributes=$_POST['Equipment'];
		        if(isset($_GET['ajax'])){
				if($model->save()){
				    echo 'save';
				    return;
				}
			    }else
			if($model->save())
				$this->redirect(array('index','custno'=>$custno,'locno'=>$locno));
		}
		 $schedule_model = EquipmentSchedule::model()->findByPk($model->id);
		if(is_null($schedule_model)) $schedule_model = new EquipmentSchedule();
		$schedule_model->equipmentid = $model->id;
		$this->render('update',array(
			'model'=>$model,
                        'location'=>$this->location,
                        'customer'=>$this->customer,
            		'schedule_model'=>$schedule_model
		));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id)
	{
	
                // we only allow deletion via POST request
                $model=$this->loadModel($id);
                $model->delete();
                // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
                if(!isset($_GET['ajax']))
                        $this->redirect (CHttpRequest::getUrlReferrer());
	
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex($custno,$locno)
	{
		$this->loadObject($custno, $locno);
                
                $this->render('index',array(
                    'location'=>$this->location,
                    'customer'=>$this->customer,
                ));
	}


        public function loadObject($custno,$locno){
            $this->location=Locations::model()->find('custno=:custno AND locno=:locno',array(
                'custno'=>$custno,
                'locno'=>$locno,
            ));
            
            $this->customer=Customers::model()->find('custno=:custno',array(
                'custno'=>$custno,
            ));
            
            if($this->location==NULL || $this->customer==NULL){
                throw new CHttpException('404','Your request could not process, that is we all know');
            }
        }
	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id)
	{
		$model=Equipment::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='equipment-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
        
        public function actionEquipmentList($custno,$locno,$query=null,$page=1,$sort=NULL,$dir=NULL,$software=null){
            //we decrease $page by 1 because in Extjs first page is 1, but in our sql first page is 0;
            if($page>0)$page--;
            
            $crit=new CDbCriteria();
            $crit->condition='custno=:custno AND locno=:locno';
            $crit->params=array(
                'custno'=>$custno,
                'locno'=>$locno,
            );
            if($query){
                $crit->compare('description', $query,true);
            }
            $order=CJSON::decode($sort);
            if($sort!=NULL){
                $crit->order=$order[0]['property'].' '.$order[0]['direction'];
            }
            
            $data=new CActiveDataProvider('Equipment',array(
                'criteria'=>$crit,
                'pagination'=>array(
                    'pageSize'=>25,
                    'currentPage'=>$page,
                )
            ));
            
            if($data!=NULL && count($data->getData())>0){
                $rs=array();
                $rs['totalCount']=$data->getTotalItemCount();
                foreach($data->getData() as $i=>$item){
                    $rs['data'][$i]=$item->getAttributes();
                    $rs['data'][$i]['pmrequiredText']=$item->pmrequiredText;
                    $rs['data'][$i]['statusText']=$item->statusText;
                    $rs['data'][$i]['planTypeText']=$item->PlanTypeText;
                    if($software==1){
                        $smContract = $this->checkSmContract($item->id);
                        if($smContract!=null){
                            $rs['data'][$i]['smContract'] = $smContract->contractid;
                        }
                    }
                }
                echo json_encode($rs);
            }
            Yii::app()->end();
        }
        public function actionEquipmentWarrantyList($custno,$locno,$query=null,$page=1,$sort=NULL,$dir=NULL,$software=null){
            //we decrease $page by 1 because in Extjs first page is 1, but in our sql first page is 0;
            if($page>0)$page--;
            
            $crit=new CDbCriteria();
            $crit->condition='custno=:custno AND locno=:locno AND warranty>= NOW()';
            $crit->params=array(
                'custno'=>$custno,
                'locno'=>$locno,
            );
            if($query){
                $crit->compare('description', $query,true);
            }
            $order=CJSON::decode($sort);
            if($sort!=NULL){
                $crit->order=$order[0]['property'].' '.$order[0]['direction'];
            }
            
            $data=new CActiveDataProvider('Equipment',array(
                'criteria'=>$crit,
                'pagination'=>array(
                    'pageSize'=>25,
                    'currentPage'=>$page,
                )
            ));
            
            if($data!=NULL && count($data->getData())>0){
                $rs=array();
                $rs['totalCount']=$data->getTotalItemCount();
                foreach($data->getData() as $i=>$item){
                    $rs['data'][$i]=$item->getAttributes();
                    $rs['data'][$i]['pmrequiredText']=$item->pmrequiredText;
                    $rs['data'][$i]['statusText']=$item->statusText;
                    $rs['data'][$i]['planTypeText']=$item->PlanTypeText;
                    if($software==1){
                        $smContract = $this->checkSmContract($item->id);
                        if($smContract!=null){
                            $rs['data'][$i]['smContract'] = $smContract->contractid;
                        }
                    }
                }
                echo json_encode($rs);
            }
            Yii::app()->end();
        }
        
        protected function checkSmContract($equipmentId){
            $ledger = ContractSoftwareMaintLedger::model()->find('equipmentno=:equipmentno',array(
                'equipmentno'=>$equipmentId
            ));
            if($ledger!=null){
                if($ledger->contract!=null && $ledger->contract->status == 2){
                    return $ledger->contract;
                }
            }
        }
}
